UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3NxLVf8PXActLCAIKqtbUvdXf+yfjhWBYuTNbf/dtZ4='
WHERE
key_id = '7a78d36abaa0ff4444ebca21c4727a6b4a5a10c5bd2a816806d3812a633bf0fd'
AND (
token = '3NxLVf8PXActLCAIKqtbUvdXf+yfjhWBYuTNbf/dtZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)