UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gmCCuOzZuF+PM1zZbboGu2iOX+m0x49Q6E9C7emvDXg='
WHERE
key_id = 'db8c17e61cd6a97ca126e334f52f36b8f2a99ec8543402a7f1de3e8afa49bff9'
AND (
token = 'gmCCuOzZuF+PM1zZbboGu2iOX+m0x49Q6E9C7emvDXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)