UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KzdAT/ZJzfduUu62ZOlrQRTZFYuFbjbmFOlkBFbyqeE='
WHERE
key_id = 'b3186c77daa1178db7e96470f2a5006d4f8a444f9566ddfc505781eaf65277ca'
AND (
token = 'KzdAT/ZJzfduUu62ZOlrQRTZFYuFbjbmFOlkBFbyqeE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)