UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4raCb67hyvns9s59dgqEIEEL1pxx7LBtrSBLLpNpdd8='
WHERE
key_id = '7d64b50389479d47ff61835bcd9ea0a89bef31f56cbad117e4681719f9e30a6e'
AND (
token = '4raCb67hyvns9s59dgqEIEEL1pxx7LBtrSBLLpNpdd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)