UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kHTK6lGDwaSbk5ehoWI1DnEu/LYNsgO0Zc0vKjOKE+g='
WHERE
key_id = 'e547340d990be8a51a0eca350247ac8455d9b428797cc75c0c9bfcd0bbe30a16'
AND (
token = 'kHTK6lGDwaSbk5ehoWI1DnEu/LYNsgO0Zc0vKjOKE+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)