UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xHjQhH/DKao/7YcLq5VQoEfjKUNQawHEXm0wwreQtcw='
WHERE
key_id = 'd0f349ab94d364e26092f9d9ad640fca0c223e10b7cd90938a16582e87005c10'
AND (
token = 'xHjQhH/DKao/7YcLq5VQoEfjKUNQawHEXm0wwreQtcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)