UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z8MmaTICS1nASE4r7kdw5LK5RHhC3Jl3SkwxLQ2184M='
WHERE
key_id = '2046f12fc81e4cf45ce372c6057f283a6c4b4e902cae2d4d1102244961c52e6e'
AND (
token = 'Z8MmaTICS1nASE4r7kdw5LK5RHhC3Jl3SkwxLQ2184M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)