UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z+ZjqKbAXNdkve+McUAL+bOpY4y6FvheC4KfA0rL8EU='
WHERE
key_id = '187df612cc1b738f2b58b503e844cb7bec30e8edb6b92f3394a775c5a1cf5977'
AND (
token = 'z+ZjqKbAXNdkve+McUAL+bOpY4y6FvheC4KfA0rL8EU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)