UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nqJxOOTEnSDUewsVRpQ97GnVgGpNhGMgGtkWfX6IIOE='
WHERE
key_id = '7123d915392544c878dd6973b55a1d3217e1584a95c21483fe6a1cd0d6c5b897'
AND (
token = 'nqJxOOTEnSDUewsVRpQ97GnVgGpNhGMgGtkWfX6IIOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)