UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ilx2XrRYoJ8S59waVOUinaeoYUcCzr+F5/M0Sdz5+GM='
WHERE
key_id = 'af47dca4204cfc77b161aee1985b037331e367f24e65319361759d733903c146'
AND (
token = 'ilx2XrRYoJ8S59waVOUinaeoYUcCzr+F5/M0Sdz5+GM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)