UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D2THGFE167cJ4Q54nImSFwdY1Io71JOR5Iua1q526+M='
WHERE
key_id = 'f038fe4f463d9c053c95f674b90e8838b9f8f44d4ca03fa1bdce5c0c97467c1d'
AND (
token = 'D2THGFE167cJ4Q54nImSFwdY1Io71JOR5Iua1q526+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)