UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CCCASIDFLUun+u8zWVsGOsDJ98BQGq8JTMSBMV/C+wM='
WHERE
key_id = 'c818f7735200701550ac6a54800d8e4875856bae82a50c4b25b4c77685289321'
AND (
token = 'CCCASIDFLUun+u8zWVsGOsDJ98BQGq8JTMSBMV/C+wM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)