UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MJIDTOHLGadPna2QWHh7oMWU8WVKFSPdCm8UQxzpVEA='
WHERE
key_id = '31d6fe172f8e3a92c9c7cb1a894fce448563d7b10dc6fb1218ebf59fe45d4555'
AND (
token = 'MJIDTOHLGadPna2QWHh7oMWU8WVKFSPdCm8UQxzpVEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)