UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SbfoZZqJYfPlfNTb61Om6jKfYQ46yrbYPvD7SEqeUEo='
WHERE
key_id = '52e4ef7ae44e502a6befcc1b8d813e322773b948321abb4f766c2eb8f58eca7c'
AND (
token = 'SbfoZZqJYfPlfNTb61Om6jKfYQ46yrbYPvD7SEqeUEo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)