UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YPhX+UeBksytjDu4X5ruXvPrbdHJuB0biSW+aNZaG8c='
WHERE
key_id = '5a5f0b71814c57efbb52d5ed8afd08cc38a42afcf46399ee9d78a6d13536ddb9'
AND (
token = 'YPhX+UeBksytjDu4X5ruXvPrbdHJuB0biSW+aNZaG8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)