UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BX519l1WQGgnASLTvXc8BWO5/UUH0BidZ3tIZi1RiGg='
WHERE
key_id = '16612fdedc2ada9117a93a6917552e8d742ea5085ec2704db38515e5f9c47141'
AND (
token = 'BX519l1WQGgnASLTvXc8BWO5/UUH0BidZ3tIZi1RiGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)