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