UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a0x2pfxtL/C9NeH+NU3GmmCABoSWnv5gc1x4zsDEHew='
WHERE
key_id = 'f2e63170a32a28ea4d8091d3bf0017e2a3a1631d647c1939babb295a60380f3f'
AND (
token = 'a0x2pfxtL/C9NeH+NU3GmmCABoSWnv5gc1x4zsDEHew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)