UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcAetuDup0akbvIn1PCreN+KhS03KGY4p3fOQpsv8eM='
WHERE
key_id = '07a4974220486140ffc1cf01e2c884b6a34de9038afa4a840570e77713dc1f71'
AND (
token = 'bcAetuDup0akbvIn1PCreN+KhS03KGY4p3fOQpsv8eM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)