UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mAlhUHlJTp+ihw409k8ljVAI7JfyuBxNyFz3/yNXyJU='
WHERE
key_id = '93a12708dd2167c688d9c8afa3c12ecf04f1e4c61d751f267632c7e3b7a700e4'
AND (
token = 'mAlhUHlJTp+ihw409k8ljVAI7JfyuBxNyFz3/yNXyJU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)