UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm1XXQxp1XJxsbMEzP6T2Oo69Q8rcR9hpPiPQPvC461w='
WHERE
key_id = '505d5f335db9a3c9147ca3b8fe2615e1374190600d7c7fac9e12e10684f675dc'
AND (
token = 'm1XXQxp1XJxsbMEzP6T2Oo69Q8rcR9hpPiPQPvC461w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)