UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yFpmWhn0NswPz6wcEH81OvqDME6Vny2a1ROCd0PHuRU='
WHERE
key_id = '9bc035b7c71f758529d2d4e1de6790693a757e89e9f749df60d3a3a89c3f4291'
AND (
token = 'yFpmWhn0NswPz6wcEH81OvqDME6Vny2a1ROCd0PHuRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)