UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mctz8TXuYA0/1sjwVo12yjLKbJ6OmCo2aCXrU2IQsyM='
WHERE
key_id = '7e227866a402a0eea0bb871e4312c8df7fbb6f860e7e2394b1088cfd65cd5157'
AND (
token = 'Mctz8TXuYA0/1sjwVo12yjLKbJ6OmCo2aCXrU2IQsyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)