UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iUs9iPSO8EskXqLB8jnIns+Ip18qvg7ME0RYLoXW5Rw='
WHERE
key_id = '78b316794dab8ad5e83418dd2b2e71aa9cbfab75cad5186d69bc70bddebbde6a'
AND (
token = 'iUs9iPSO8EskXqLB8jnIns+Ip18qvg7ME0RYLoXW5Rw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)