UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '31glzD7X0gQMSKixkcZyqbUY6h3TngWIMr4nyIlgljg='
WHERE
key_id = '4b05da1bd7042e4ae39de8e3b5e8ec749e3866f7e0b6d9c118f6086b8ab411bf'
AND (
token = '31glzD7X0gQMSKixkcZyqbUY6h3TngWIMr4nyIlgljg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)