UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qS3DTtoXugHdronIaEuFDxtyzKIeMUTVtKcbHEPc8L8='
WHERE
key_id = 'a9a933e24b45094bba76e4c15b5e6e7f3d792c1b7a4ad26ef7cc9603f2ebe10c'
AND (
token = 'qS3DTtoXugHdronIaEuFDxtyzKIeMUTVtKcbHEPc8L8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)