UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a0ZDbvZWmzoi4jHlZ8Jz54b/cLFiTDnwy7Sq+aNZXaw='
WHERE
key_id = '372e5ec60e4a7c1715adbf24fc0d6b1ce8030c7c8bf4fc6fb96bea413a3b1470'
AND (
token = 'a0ZDbvZWmzoi4jHlZ8Jz54b/cLFiTDnwy7Sq+aNZXaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)