UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y8sXtcfO/ojm4YBhEF1f5o8lvvWhlULRQExBtKMyK64='
WHERE
key_id = '78b9c8f4d05acbe57b43f165475b9ca8118b45af55d160cfdf86d908823f6594'
AND (
token = 'Y8sXtcfO/ojm4YBhEF1f5o8lvvWhlULRQExBtKMyK64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)