UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PHX4jz2As015I/BP24kf62tpFvey2GzWBL270QrBccQ='
WHERE
key_id = 'b7c3a163f97cb9dfd9e440016d39872cc07e838a831065618c7f268ee78941b1'
AND (
token = 'PHX4jz2As015I/BP24kf62tpFvey2GzWBL270QrBccQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)