UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uKzIpdivc7cRvSd4samwjIz4wahjRlnDDsj+aSSANME='
WHERE
key_id = 'c1bc20a228c93787bff0a3220ac5f9304ec9f9bafb5857ad6b364ca52410cac8'
AND (
token = 'uKzIpdivc7cRvSd4samwjIz4wahjRlnDDsj+aSSANME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)