UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4sOZDx6mbEapLPC22g0nvMDDmqhzDG/AfIjPSLJiKMM='
WHERE
key_id = '0be8ee098c2e60cc90e2d8db9ea3feec57ad17501a05eacbd69121e56471a6b6'
AND (
token = '4sOZDx6mbEapLPC22g0nvMDDmqhzDG/AfIjPSLJiKMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)