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