UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PLj82lQ18nWL5QJ1Oh/mPz2qqxFVwYCGkIUFmG9lCkA='
WHERE
key_id = 'bc573cda2faf316cc6e88a981582a7bb93241eca32948d253b58ce7cd76ce936'
AND (
token = 'PLj82lQ18nWL5QJ1Oh/mPz2qqxFVwYCGkIUFmG9lCkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)