UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oGQeApYzQL1gfAJyrNxbmQl/1cLA0Y9vfHD9qfBSO78='
WHERE
key_id = 'fd4b2fdd5137a282ed170f30f081504ac0e0f9ba3d3671e9194d5f0407280a82'
AND (
token = 'oGQeApYzQL1gfAJyrNxbmQl/1cLA0Y9vfHD9qfBSO78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)