UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YHsVnYuWeWXj3vZMBl65vaMoIKa2DeUDdEUTZKQZR+I='
WHERE
key_id = '0e2456830777b1d426aa466dc585ccc6af5d31853a2104bdf0b4b007cb209480'
AND (
token = 'YHsVnYuWeWXj3vZMBl65vaMoIKa2DeUDdEUTZKQZR+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)