UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0kTvVyU0DSEiApaQRbBtYOSForshHMW2CIL4aEsv98o='
WHERE
key_id = '5bd263f5543069f1c88e513e5f4e60b564a7868ddda0e8012b47e5e6c4150ee1'
AND (
token = '0kTvVyU0DSEiApaQRbBtYOSForshHMW2CIL4aEsv98o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)