UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PExyDUh0W8fq5xNCrTPsjdcClwJvfcmPAnTlIHl+wYk='
WHERE
key_id = '79a47aa2dd4c42999f851e64439460855f96d80ead39e49e81a586547a205476'
AND (
token = 'PExyDUh0W8fq5xNCrTPsjdcClwJvfcmPAnTlIHl+wYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)