UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q9nnpgdnIT7998YDlkASQ0y78HxaT+uEoz9IE07V4kU='
WHERE
key_id = 'f02071d5550ec5fef27ec8b775393bd6ef21a68f6c7e6ca527fcba426d1103f2'
AND (
token = 'q9nnpgdnIT7998YDlkASQ0y78HxaT+uEoz9IE07V4kU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)