UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T9E9sZSA/yR8q6Zj5TfG8Iv6pnHzTCmRD4t0GlxF3k4='
WHERE
key_id = '6f2c45ae97060d1d7b03add0f182d4c28e28f43acde6321ca8abb0a5928ff488'
AND (
token = 'T9E9sZSA/yR8q6Zj5TfG8Iv6pnHzTCmRD4t0GlxF3k4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)