UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oiTYjgko9Y2xNuFBKEohqhAHMPMc1mSbYMAgaaqLQF8='
WHERE
key_id = '1a5baaff61d18f6c84e0d5b320e2501dc348446dedff25a27e3a7c8a392b90f5'
AND (
token = 'oiTYjgko9Y2xNuFBKEohqhAHMPMc1mSbYMAgaaqLQF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)