UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qNL5s6lu4YYLVcT/fCOMj/0o3In04EWDyBzCIhtRZGg='
WHERE
key_id = 'ffd3efa132588c92606b0ad019244c436c9335ecf13664520ac0e3a44b24a5d5'
AND (
token = 'qNL5s6lu4YYLVcT/fCOMj/0o3In04EWDyBzCIhtRZGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)