UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aFJFTPbPrFrmHIMvmYzZtIJ08I+xGo+O8aHpX6x73UU='
WHERE
key_id = 'e982de6883aba0554e66d57b532a93844327a3af8af8609665fb2187ce9b97c6'
AND (
token = 'aFJFTPbPrFrmHIMvmYzZtIJ08I+xGo+O8aHpX6x73UU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)